{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-01T03:04:41.273619Z",
     "start_time": "2019-11-01T03:04:36.371734Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>记录数</th>\n",
       "      <th>accept_area_name</th>\n",
       "      <th>cert_no_cipher</th>\n",
       "      <th>complete_time</th>\n",
       "      <th>contract_no</th>\n",
       "      <th>txn_amount</th>\n",
       "      <th>user_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>466155454E446E34597969376646395346356A31534349...</td>\n",
       "      <td>2017/12/27 5:12:24</td>\n",
       "      <td>17703211024</td>\n",
       "      <td>117000</td>\n",
       "      <td>刘骏腾</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>4C77623869617155705A613552464D5A435A6E36644945...</td>\n",
       "      <td>2017/10/18 1:38:52</td>\n",
       "      <td>18009450452</td>\n",
       "      <td>39000</td>\n",
       "      <td>李娟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>702B4570464A4A686F53684871336273365647792F6572...</td>\n",
       "      <td>2017/10/30 7:47:15</td>\n",
       "      <td>17318976182</td>\n",
       "      <td>116400</td>\n",
       "      <td>黄朝明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>64354130566B4632432B724A4C4D766F4F35784D2F6E32...</td>\n",
       "      <td>2017/12/11 7:52:30</td>\n",
       "      <td>13316686792</td>\n",
       "      <td>117000</td>\n",
       "      <td>钟家俊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>安徽省</td>\n",
       "      <td>6A50504B3976626B77624C68514C454C52716C78746F55...</td>\n",
       "      <td>2017/12/21 5:22:08</td>\n",
       "      <td>18010822175</td>\n",
       "      <td>100000</td>\n",
       "      <td>李婷</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>5A6454336F30684658464B6D4A3439494253527530715A...</td>\n",
       "      <td>2017/10/5 2:34:27</td>\n",
       "      <td>18084919078</td>\n",
       "      <td>39000</td>\n",
       "      <td>何明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>3430452F576833676E2F7A3732614972697662514D2B4D...</td>\n",
       "      <td>2017/10/29 3:01:19</td>\n",
       "      <td>15348254092</td>\n",
       "      <td>98900</td>\n",
       "      <td>吴昌发</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>3331475A5A526C6D414F7A397A2B426E4E742F6D715733...</td>\n",
       "      <td>2017/12/13 4:03:48</td>\n",
       "      <td>18925351119</td>\n",
       "      <td>97500</td>\n",
       "      <td>林云</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>414D7648786657687256656E474A7A3365704B574A6442...</td>\n",
       "      <td>2017/12/26 3:47:22</td>\n",
       "      <td>17709006823</td>\n",
       "      <td>195100</td>\n",
       "      <td>张强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>4F644D745A796544334E304244587461425A61334D5779...</td>\n",
       "      <td>2017/12/24 8:12:09</td>\n",
       "      <td>13303325865</td>\n",
       "      <td>101400</td>\n",
       "      <td>王鹏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>2B6D327A33773966307266326E747568503732764C454D...</td>\n",
       "      <td>2017/12/23 1:52:17</td>\n",
       "      <td>18081916360</td>\n",
       "      <td>98900</td>\n",
       "      <td>杨华芳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>河南省</td>\n",
       "      <td>777963563447574A74764F66624F72386A6F76724F4230...</td>\n",
       "      <td>2017/10/2 4:39:00</td>\n",
       "      <td>18137759385</td>\n",
       "      <td>97500</td>\n",
       "      <td>谷国粮</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>64657A694E397877554A4C64394D4D3875795A65566630...</td>\n",
       "      <td>2017/11/11 8:42:52</td>\n",
       "      <td>15383304666</td>\n",
       "      <td>195100</td>\n",
       "      <td>颜张伟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>6F6557306F613758676A69542F7765495742474C317341...</td>\n",
       "      <td>2017/12/13 4:20:04</td>\n",
       "      <td>17709352885</td>\n",
       "      <td>39000</td>\n",
       "      <td>罗金龙</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>385459616839546F31596A3663395A582B6E5A3336467A...</td>\n",
       "      <td>2017/11/26 8:03:21</td>\n",
       "      <td>17740174677</td>\n",
       "      <td>116400</td>\n",
       "      <td>胡杰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>58496A306275784E79362F2B347934557943652B44414F...</td>\n",
       "      <td>2017/12/5 3:21:18</td>\n",
       "      <td>13378333929</td>\n",
       "      <td>116400</td>\n",
       "      <td>骆强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>4C466E47536D4D574B686A2B436670696B435A316A4E70...</td>\n",
       "      <td>2017/12/23 9:13:40</td>\n",
       "      <td>18131818550</td>\n",
       "      <td>101400</td>\n",
       "      <td>周志鑫</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>6B3768784E675059624F303078302B3645745055636654...</td>\n",
       "      <td>2017/12/16 9:34:42</td>\n",
       "      <td>13380143329</td>\n",
       "      <td>78000</td>\n",
       "      <td>谢永强</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>4951424C4B32493570584B712B446553794955586E304C...</td>\n",
       "      <td>2017/12/21 2:13:08</td>\n",
       "      <td>19981216385</td>\n",
       "      <td>77600</td>\n",
       "      <td>何波</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>414D764878665768725666302F367438666A4A54677650...</td>\n",
       "      <td>2017/11/18 6:45:41</td>\n",
       "      <td>13350962911</td>\n",
       "      <td>65900</td>\n",
       "      <td>张小伟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1</td>\n",
       "      <td>新疆维吾尔自治区</td>\n",
       "      <td>71324E74686B55535476674B636B363343315631414D64...</td>\n",
       "      <td>2017/10/11 11:24:24</td>\n",
       "      <td>18129361493</td>\n",
       "      <td>48600</td>\n",
       "      <td>曲延飞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>63324C744656555136663245614F67642B75552F44736B...</td>\n",
       "      <td>2017/12/24 2:33:57</td>\n",
       "      <td>13346498813</td>\n",
       "      <td>97500</td>\n",
       "      <td>陈秋萍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1</td>\n",
       "      <td>上海市</td>\n",
       "      <td>7844424E4E7554676276557044664561714B305451584C...</td>\n",
       "      <td>2017/11/7 8:23:01</td>\n",
       "      <td>17701819598</td>\n",
       "      <td>24</td>\n",
       "      <td>钱耀华</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>4D6469776D4D3933434179317545637A636561476C456A...</td>\n",
       "      <td>2017/12/18 9:27:03</td>\n",
       "      <td>18002901882</td>\n",
       "      <td>117000</td>\n",
       "      <td>滕茂林</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>414D764878665768725665304B664B4830316C62744933...</td>\n",
       "      <td>2017/12/30 6:57:40</td>\n",
       "      <td>17386720182</td>\n",
       "      <td>77600</td>\n",
       "      <td>黄晓琼</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>5A576344456737434539742B61632B2F5643534B303948...</td>\n",
       "      <td>2017/12/2 5:15:57</td>\n",
       "      <td>18931169883</td>\n",
       "      <td>195100</td>\n",
       "      <td>杨海磊</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>5A7145384F746D6C3735527A61326E4D5862592F553058...</td>\n",
       "      <td>2017/12/22 9:11:27</td>\n",
       "      <td>13323245666</td>\n",
       "      <td>175600</td>\n",
       "      <td>赵军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1</td>\n",
       "      <td>新疆维吾尔自治区</td>\n",
       "      <td>6C4473336B656532587074734B55354877702B66494438...</td>\n",
       "      <td>2017/12/14 5:57:00</td>\n",
       "      <td>18097713889</td>\n",
       "      <td>48700</td>\n",
       "      <td>易增山</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1</td>\n",
       "      <td>浙江省</td>\n",
       "      <td>6478624F75504F7368662B575A6D386B37624379564253...</td>\n",
       "      <td>2017/12/25 5:43:41</td>\n",
       "      <td>18058521379</td>\n",
       "      <td>74000</td>\n",
       "      <td>胡建绒</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>7A62586E4E702B2B386650584A49736230477578733345...</td>\n",
       "      <td>2017/12/31 3:47:16</td>\n",
       "      <td>15328233788</td>\n",
       "      <td>77600</td>\n",
       "      <td>王忠</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263215</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>596F36726F717439344F542F4667644D4A42666A474D76...</td>\n",
       "      <td>2017/10/13 1:41:03</td>\n",
       "      <td>13388282777</td>\n",
       "      <td>195100</td>\n",
       "      <td>黄志刚</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263216</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>4966327775426D364A696D6474634855354F783468722B...</td>\n",
       "      <td>2017/11/4 6:58:30</td>\n",
       "      <td>13373481999</td>\n",
       "      <td>101400</td>\n",
       "      <td>卢凤超</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263217</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>576A4641684F3562534B3541373364495979594451754E...</td>\n",
       "      <td>2017/10/7 7:47:12</td>\n",
       "      <td>18008255294</td>\n",
       "      <td>116400</td>\n",
       "      <td>康芳</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263218</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>6D625A6F56346A686D31666C58786D624B6F7667645532...</td>\n",
       "      <td>2017/10/13 8:18:47</td>\n",
       "      <td>17743344611</td>\n",
       "      <td>116400</td>\n",
       "      <td>胡水清</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263219</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>576A53757659424F665065743552676250656731336943...</td>\n",
       "      <td>2017/10/31 7:03:12</td>\n",
       "      <td>18131986936</td>\n",
       "      <td>99900</td>\n",
       "      <td>闫喜英</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263220</th>\n",
       "      <td>1</td>\n",
       "      <td>新疆维吾尔自治区</td>\n",
       "      <td>586D44412F374538437539373478656172502B4668627A...</td>\n",
       "      <td>2017/11/30 8:08:03</td>\n",
       "      <td>18997981148</td>\n",
       "      <td>48600</td>\n",
       "      <td>陈金凤</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263221</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>46446B356F2F4450542F6A6349493532354F4E74654830...</td>\n",
       "      <td>2017/12/23 8:53:33</td>\n",
       "      <td>13323224388</td>\n",
       "      <td>175600</td>\n",
       "      <td>杨立兴</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263222</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>366C722F4D62765A424673735872665A51444879324844...</td>\n",
       "      <td>2017/12/31 3:51:47</td>\n",
       "      <td>17790518781</td>\n",
       "      <td>50300</td>\n",
       "      <td>苏登峰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263223</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>59505473355A552F64567561526C794232636D46635959...</td>\n",
       "      <td>2017/12/10 9:17:04</td>\n",
       "      <td>18931207597</td>\n",
       "      <td>101400</td>\n",
       "      <td>王浩</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263224</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>6F7250357947572F6E7264374172353052767252464F79...</td>\n",
       "      <td>2017/12/20 6:13:54</td>\n",
       "      <td>15383968843</td>\n",
       "      <td>97500</td>\n",
       "      <td>金晓勇</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263225</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>58364C79734E35784C6B61634D6B366669555A73306B76...</td>\n",
       "      <td>2017/12/9 6:56:48</td>\n",
       "      <td>18931654353</td>\n",
       "      <td>101400</td>\n",
       "      <td>高玉环</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263226</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>48503858427338495063436E4365424F7A6C4A597A6755...</td>\n",
       "      <td>2017/10/2 2:37:50</td>\n",
       "      <td>18081409815</td>\n",
       "      <td>65900</td>\n",
       "      <td>袁瑛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263227</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>75572F37525978475172437251716E4562427A534C612B...</td>\n",
       "      <td>2017/11/16 3:31:14</td>\n",
       "      <td>15303135333</td>\n",
       "      <td>195100</td>\n",
       "      <td>曹小军</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263228</th>\n",
       "      <td>1</td>\n",
       "      <td>山西省</td>\n",
       "      <td>3547336A34564D5762784E36553048456968677A6A6764...</td>\n",
       "      <td>2017/11/24 9:32:02</td>\n",
       "      <td>15340692733</td>\n",
       "      <td>56000</td>\n",
       "      <td>刘永盛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263229</th>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>774830446A62336F7458374C692B7936392B66572B5971...</td>\n",
       "      <td>2017/12/24 11:03:05</td>\n",
       "      <td>13360926040</td>\n",
       "      <td>105300</td>\n",
       "      <td>廖小海</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263230</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>3950795A2F4D6B504C496D497365326C3673796B79466C...</td>\n",
       "      <td>2017/11/28 4:19:50</td>\n",
       "      <td>18103396232</td>\n",
       "      <td>101400</td>\n",
       "      <td>张江涛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263231</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>69585062573656333649617A31624B785847554E6A2B52...</td>\n",
       "      <td>2017/11/30 7:28:58</td>\n",
       "      <td>18108254279</td>\n",
       "      <td>116400</td>\n",
       "      <td>卢玉梅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263232</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>375377366869746F77535A2F51746D47376B4B706F7656...</td>\n",
       "      <td>2017/12/30 6:19:04</td>\n",
       "      <td>19940750563</td>\n",
       "      <td>39000</td>\n",
       "      <td>方盛</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263233</th>\n",
       "      <td>1</td>\n",
       "      <td>安徽省</td>\n",
       "      <td>673158506F747563303271556E544F4A6571697461774D...</td>\n",
       "      <td>2017/12/15 8:54:21</td>\n",
       "      <td>15305567000</td>\n",
       "      <td>39000</td>\n",
       "      <td>方书冬</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263234</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>685756705848574C6542566E43354E63372B44786F4575...</td>\n",
       "      <td>2017/12/15 4:58:10</td>\n",
       "      <td>18144369819</td>\n",
       "      <td>116400</td>\n",
       "      <td>黄金秀</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263235</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>30614B68747A7A352F73683352415654674F37796D6236...</td>\n",
       "      <td>2017/11/22 5:16:09</td>\n",
       "      <td>18932502092</td>\n",
       "      <td>195100</td>\n",
       "      <td>岑书伟</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263236</th>\n",
       "      <td>1</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>7A3745473857634A3445757A4E646E4A31345738354358...</td>\n",
       "      <td>2017/11/19 8:50:37</td>\n",
       "      <td>15352215990</td>\n",
       "      <td>39000</td>\n",
       "      <td>王鸿鹏</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263237</th>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>45342B667455486D4E5252574D74676F39336D78723733...</td>\n",
       "      <td>2017/12/5 9:35:36</td>\n",
       "      <td>18922555561</td>\n",
       "      <td>105300</td>\n",
       "      <td>姚杰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263238</th>\n",
       "      <td>1</td>\n",
       "      <td>河北省</td>\n",
       "      <td>7336756B307654316F37486B6F434A5654453065673753...</td>\n",
       "      <td>2017/12/26 8:56:55</td>\n",
       "      <td>17713169968</td>\n",
       "      <td>101400</td>\n",
       "      <td>齐小金</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263239</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>6265544A7168757A304551726F656777396F6C7A365568...</td>\n",
       "      <td>2017/12/17 11:32:33</td>\n",
       "      <td>18990818270</td>\n",
       "      <td>50300</td>\n",
       "      <td>杨朝霞</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263240</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>2F45355374477156745462664850566C3455304C6E616E...</td>\n",
       "      <td>2017/10/6 8:27:04</td>\n",
       "      <td>18982552315</td>\n",
       "      <td>39000</td>\n",
       "      <td>赖永兰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263241</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>2B6D327A337739663072654A4F336F794176302B6B4162...</td>\n",
       "      <td>2017/12/25 7:45:58</td>\n",
       "      <td>17780451926</td>\n",
       "      <td>77600</td>\n",
       "      <td>刘萍</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263242</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>365A756152377669727977347A4543533051506176496C...</td>\n",
       "      <td>2017/12/31 6:18:04</td>\n",
       "      <td>19982814363</td>\n",
       "      <td>116400</td>\n",
       "      <td>韩云锋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263243</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>7431555233354666715463434B65676B322F7934764E50...</td>\n",
       "      <td>2017/12/8 10:03:17</td>\n",
       "      <td>18030837004</td>\n",
       "      <td>77600</td>\n",
       "      <td>赵春福</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263244</th>\n",
       "      <td>1</td>\n",
       "      <td>四川省</td>\n",
       "      <td>366C722F4D62765A4246736C644F6D74694D774A775074...</td>\n",
       "      <td>2017/11/9 7:05:26</td>\n",
       "      <td>15328875122</td>\n",
       "      <td>116400</td>\n",
       "      <td>郭毅超</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>263245 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        记录数 accept_area_name  \\\n",
       "0         1              河北省   \n",
       "1         1              甘肃省   \n",
       "2         1              四川省   \n",
       "3         1              广东省   \n",
       "4         1              安徽省   \n",
       "5         1              四川省   \n",
       "6         1              四川省   \n",
       "7         1              广东省   \n",
       "8         1              四川省   \n",
       "9         1              河北省   \n",
       "10        1              四川省   \n",
       "11        1              河南省   \n",
       "12        1              河北省   \n",
       "13        1              甘肃省   \n",
       "14        1              四川省   \n",
       "15        1              四川省   \n",
       "16        1              河北省   \n",
       "17        1              广东省   \n",
       "18        1              四川省   \n",
       "19        1              四川省   \n",
       "20        1         新疆维吾尔自治区   \n",
       "21        1              广东省   \n",
       "22        1              上海市   \n",
       "23        1              广东省   \n",
       "24        1              四川省   \n",
       "25        1              河北省   \n",
       "26        1              河北省   \n",
       "27        1         新疆维吾尔自治区   \n",
       "28        1              浙江省   \n",
       "29        1              四川省   \n",
       "...     ...              ...   \n",
       "263215    1              四川省   \n",
       "263216    1              河北省   \n",
       "263217    1              四川省   \n",
       "263218    1              四川省   \n",
       "263219    1              河北省   \n",
       "263220    1         新疆维吾尔自治区   \n",
       "263221    1              河北省   \n",
       "263222    1              四川省   \n",
       "263223    1              河北省   \n",
       "263224    1              河北省   \n",
       "263225    1              河北省   \n",
       "263226    1              四川省   \n",
       "263227    1              河北省   \n",
       "263228    1              山西省   \n",
       "263229    1              广东省   \n",
       "263230    1              河北省   \n",
       "263231    1              四川省   \n",
       "263232    1              四川省   \n",
       "263233    1              安徽省   \n",
       "263234    1              四川省   \n",
       "263235    1              河北省   \n",
       "263236    1              甘肃省   \n",
       "263237    1              广东省   \n",
       "263238    1              河北省   \n",
       "263239    1              四川省   \n",
       "263240    1              四川省   \n",
       "263241    1              四川省   \n",
       "263242    1              四川省   \n",
       "263243    1              四川省   \n",
       "263244    1              四川省   \n",
       "\n",
       "                                           cert_no_cipher  \\\n",
       "0       466155454E446E34597969376646395346356A31534349...   \n",
       "1       4C77623869617155705A613552464D5A435A6E36644945...   \n",
       "2       702B4570464A4A686F53684871336273365647792F6572...   \n",
       "3       64354130566B4632432B724A4C4D766F4F35784D2F6E32...   \n",
       "4       6A50504B3976626B77624C68514C454C52716C78746F55...   \n",
       "5       5A6454336F30684658464B6D4A3439494253527530715A...   \n",
       "6       3430452F576833676E2F7A3732614972697662514D2B4D...   \n",
       "7       3331475A5A526C6D414F7A397A2B426E4E742F6D715733...   \n",
       "8       414D7648786657687256656E474A7A3365704B574A6442...   \n",
       "9       4F644D745A796544334E304244587461425A61334D5779...   \n",
       "10      2B6D327A33773966307266326E747568503732764C454D...   \n",
       "11      777963563447574A74764F66624F72386A6F76724F4230...   \n",
       "12      64657A694E397877554A4C64394D4D3875795A65566630...   \n",
       "13      6F6557306F613758676A69542F7765495742474C317341...   \n",
       "14      385459616839546F31596A3663395A582B6E5A3336467A...   \n",
       "15      58496A306275784E79362F2B347934557943652B44414F...   \n",
       "16      4C466E47536D4D574B686A2B436670696B435A316A4E70...   \n",
       "17      6B3768784E675059624F303078302B3645745055636654...   \n",
       "18      4951424C4B32493570584B712B446553794955586E304C...   \n",
       "19      414D764878665768725666302F367438666A4A54677650...   \n",
       "20      71324E74686B55535476674B636B363343315631414D64...   \n",
       "21      63324C744656555136663245614F67642B75552F44736B...   \n",
       "22      7844424E4E7554676276557044664561714B305451584C...   \n",
       "23      4D6469776D4D3933434179317545637A636561476C456A...   \n",
       "24      414D764878665768725665304B664B4830316C62744933...   \n",
       "25      5A576344456737434539742B61632B2F5643534B303948...   \n",
       "26      5A7145384F746D6C3735527A61326E4D5862592F553058...   \n",
       "27      6C4473336B656532587074734B55354877702B66494438...   \n",
       "28      6478624F75504F7368662B575A6D386B37624379564253...   \n",
       "29      7A62586E4E702B2B386650584A49736230477578733345...   \n",
       "...                                                   ...   \n",
       "263215  596F36726F717439344F542F4667644D4A42666A474D76...   \n",
       "263216  4966327775426D364A696D6474634855354F783468722B...   \n",
       "263217  576A4641684F3562534B3541373364495979594451754E...   \n",
       "263218  6D625A6F56346A686D31666C58786D624B6F7667645532...   \n",
       "263219  576A53757659424F665065743552676250656731336943...   \n",
       "263220  586D44412F374538437539373478656172502B4668627A...   \n",
       "263221  46446B356F2F4450542F6A6349493532354F4E74654830...   \n",
       "263222  366C722F4D62765A424673735872665A51444879324844...   \n",
       "263223  59505473355A552F64567561526C794232636D46635959...   \n",
       "263224  6F7250357947572F6E7264374172353052767252464F79...   \n",
       "263225  58364C79734E35784C6B61634D6B366669555A73306B76...   \n",
       "263226  48503858427338495063436E4365424F7A6C4A597A6755...   \n",
       "263227  75572F37525978475172437251716E4562427A534C612B...   \n",
       "263228  3547336A34564D5762784E36553048456968677A6A6764...   \n",
       "263229  774830446A62336F7458374C692B7936392B66572B5971...   \n",
       "263230  3950795A2F4D6B504C496D497365326C3673796B79466C...   \n",
       "263231  69585062573656333649617A31624B785847554E6A2B52...   \n",
       "263232  375377366869746F77535A2F51746D47376B4B706F7656...   \n",
       "263233  673158506F747563303271556E544F4A6571697461774D...   \n",
       "263234  685756705848574C6542566E43354E63372B44786F4575...   \n",
       "263235  30614B68747A7A352F73683352415654674F37796D6236...   \n",
       "263236  7A3745473857634A3445757A4E646E4A31345738354358...   \n",
       "263237  45342B667455486D4E5252574D74676F39336D78723733...   \n",
       "263238  7336756B307654316F37486B6F434A5654453065673753...   \n",
       "263239  6265544A7168757A304551726F656777396F6C7A365568...   \n",
       "263240  2F45355374477156745462664850566C3455304C6E616E...   \n",
       "263241  2B6D327A337739663072654A4F336F794176302B6B4162...   \n",
       "263242  365A756152377669727977347A4543533051506176496C...   \n",
       "263243  7431555233354666715463434B65676B322F7934764E50...   \n",
       "263244  366C722F4D62765A4246736C644F6D74694D774A775074...   \n",
       "\n",
       "              complete_time  contract_no  txn_amount user_name  \n",
       "0        2017/12/27 5:12:24  17703211024      117000       刘骏腾  \n",
       "1        2017/10/18 1:38:52  18009450452       39000        李娟  \n",
       "2        2017/10/30 7:47:15  17318976182      116400       黄朝明  \n",
       "3        2017/12/11 7:52:30  13316686792      117000       钟家俊  \n",
       "4        2017/12/21 5:22:08  18010822175      100000        李婷  \n",
       "5         2017/10/5 2:34:27  18084919078       39000        何明  \n",
       "6        2017/10/29 3:01:19  15348254092       98900       吴昌发  \n",
       "7        2017/12/13 4:03:48  18925351119       97500        林云  \n",
       "8        2017/12/26 3:47:22  17709006823      195100        张强  \n",
       "9        2017/12/24 8:12:09  13303325865      101400        王鹏  \n",
       "10       2017/12/23 1:52:17  18081916360       98900       杨华芳  \n",
       "11        2017/10/2 4:39:00  18137759385       97500       谷国粮  \n",
       "12       2017/11/11 8:42:52  15383304666      195100       颜张伟  \n",
       "13       2017/12/13 4:20:04  17709352885       39000       罗金龙  \n",
       "14       2017/11/26 8:03:21  17740174677      116400        胡杰  \n",
       "15        2017/12/5 3:21:18  13378333929      116400        骆强  \n",
       "16       2017/12/23 9:13:40  18131818550      101400       周志鑫  \n",
       "17       2017/12/16 9:34:42  13380143329       78000       谢永强  \n",
       "18       2017/12/21 2:13:08  19981216385       77600        何波  \n",
       "19       2017/11/18 6:45:41  13350962911       65900       张小伟  \n",
       "20      2017/10/11 11:24:24  18129361493       48600       曲延飞  \n",
       "21       2017/12/24 2:33:57  13346498813       97500       陈秋萍  \n",
       "22        2017/11/7 8:23:01  17701819598          24       钱耀华  \n",
       "23       2017/12/18 9:27:03  18002901882      117000       滕茂林  \n",
       "24       2017/12/30 6:57:40  17386720182       77600       黄晓琼  \n",
       "25        2017/12/2 5:15:57  18931169883      195100       杨海磊  \n",
       "26       2017/12/22 9:11:27  13323245666      175600        赵军  \n",
       "27       2017/12/14 5:57:00  18097713889       48700       易增山  \n",
       "28       2017/12/25 5:43:41  18058521379       74000       胡建绒  \n",
       "29       2017/12/31 3:47:16  15328233788       77600        王忠  \n",
       "...                     ...          ...         ...       ...  \n",
       "263215   2017/10/13 1:41:03  13388282777      195100       黄志刚  \n",
       "263216    2017/11/4 6:58:30  13373481999      101400       卢凤超  \n",
       "263217    2017/10/7 7:47:12  18008255294      116400        康芳  \n",
       "263218   2017/10/13 8:18:47  17743344611      116400       胡水清  \n",
       "263219   2017/10/31 7:03:12  18131986936       99900       闫喜英  \n",
       "263220   2017/11/30 8:08:03  18997981148       48600       陈金凤  \n",
       "263221   2017/12/23 8:53:33  13323224388      175600       杨立兴  \n",
       "263222   2017/12/31 3:51:47  17790518781       50300       苏登峰  \n",
       "263223   2017/12/10 9:17:04  18931207597      101400        王浩  \n",
       "263224   2017/12/20 6:13:54  15383968843       97500       金晓勇  \n",
       "263225    2017/12/9 6:56:48  18931654353      101400       高玉环  \n",
       "263226    2017/10/2 2:37:50  18081409815       65900        袁瑛  \n",
       "263227   2017/11/16 3:31:14  15303135333      195100       曹小军  \n",
       "263228   2017/11/24 9:32:02  15340692733       56000       刘永盛  \n",
       "263229  2017/12/24 11:03:05  13360926040      105300       廖小海  \n",
       "263230   2017/11/28 4:19:50  18103396232      101400       张江涛  \n",
       "263231   2017/11/30 7:28:58  18108254279      116400       卢玉梅  \n",
       "263232   2017/12/30 6:19:04  19940750563       39000        方盛  \n",
       "263233   2017/12/15 8:54:21  15305567000       39000       方书冬  \n",
       "263234   2017/12/15 4:58:10  18144369819      116400       黄金秀  \n",
       "263235   2017/11/22 5:16:09  18932502092      195100       岑书伟  \n",
       "263236   2017/11/19 8:50:37  15352215990       39000       王鸿鹏  \n",
       "263237    2017/12/5 9:35:36  18922555561      105300        姚杰  \n",
       "263238   2017/12/26 8:56:55  17713169968      101400       齐小金  \n",
       "263239  2017/12/17 11:32:33  18990818270       50300       杨朝霞  \n",
       "263240    2017/10/6 8:27:04  18982552315       39000       赖永兰  \n",
       "263241   2017/12/25 7:45:58  17780451926       77600        刘萍  \n",
       "263242   2017/12/31 6:18:04  19982814363      116400       韩云锋  \n",
       "263243   2017/12/8 10:03:17  18030837004       77600       赵春福  \n",
       "263244    2017/11/9 7:05:26  15328875122      116400       郭毅超  \n",
       "\n",
       "[263245 rows x 7 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "data = pd.read_csv(r'D:\\数据\\mob22+未逾期\\mob22+未逾期.csv')\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-01T03:05:53.637099Z",
     "start_time": "2019-11-01T03:05:53.627127Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         466155454E446E34597969376646395346356A31534349...\n",
       "1         4C77623869617155705A613552464D5A435A6E36644945...\n",
       "2         702B4570464A4A686F53684871336273365647792F6572...\n",
       "3         64354130566B4632432B724A4C4D766F4F35784D2F6E32...\n",
       "4         6A50504B3976626B77624C68514C454C52716C78746F55...\n",
       "5         5A6454336F30684658464B6D4A3439494253527530715A...\n",
       "6         3430452F576833676E2F7A3732614972697662514D2B4D...\n",
       "7         3331475A5A526C6D414F7A397A2B426E4E742F6D715733...\n",
       "8         414D7648786657687256656E474A7A3365704B574A6442...\n",
       "9         4F644D745A796544334E304244587461425A61334D5779...\n",
       "10        2B6D327A33773966307266326E747568503732764C454D...\n",
       "11        777963563447574A74764F66624F72386A6F76724F4230...\n",
       "12        64657A694E397877554A4C64394D4D3875795A65566630...\n",
       "13        6F6557306F613758676A69542F7765495742474C317341...\n",
       "14        385459616839546F31596A3663395A582B6E5A3336467A...\n",
       "15        58496A306275784E79362F2B347934557943652B44414F...\n",
       "16        4C466E47536D4D574B686A2B436670696B435A316A4E70...\n",
       "17        6B3768784E675059624F303078302B3645745055636654...\n",
       "18        4951424C4B32493570584B712B446553794955586E304C...\n",
       "19        414D764878665768725666302F367438666A4A54677650...\n",
       "20        71324E74686B55535476674B636B363343315631414D64...\n",
       "21        63324C744656555136663245614F67642B75552F44736B...\n",
       "22        7844424E4E7554676276557044664561714B305451584C...\n",
       "23        4D6469776D4D3933434179317545637A636561476C456A...\n",
       "24        414D764878665768725665304B664B4830316C62744933...\n",
       "25        5A576344456737434539742B61632B2F5643534B303948...\n",
       "26        5A7145384F746D6C3735527A61326E4D5862592F553058...\n",
       "27        6C4473336B656532587074734B55354877702B66494438...\n",
       "28        6478624F75504F7368662B575A6D386B37624379564253...\n",
       "29        7A62586E4E702B2B386650584A49736230477578733345...\n",
       "                                ...                        \n",
       "263215    596F36726F717439344F542F4667644D4A42666A474D76...\n",
       "263216    4966327775426D364A696D6474634855354F783468722B...\n",
       "263217    576A4641684F3562534B3541373364495979594451754E...\n",
       "263218    6D625A6F56346A686D31666C58786D624B6F7667645532...\n",
       "263219    576A53757659424F665065743552676250656731336943...\n",
       "263220    586D44412F374538437539373478656172502B4668627A...\n",
       "263221    46446B356F2F4450542F6A6349493532354F4E74654830...\n",
       "263222    366C722F4D62765A424673735872665A51444879324844...\n",
       "263223    59505473355A552F64567561526C794232636D46635959...\n",
       "263224    6F7250357947572F6E7264374172353052767252464F79...\n",
       "263225    58364C79734E35784C6B61634D6B366669555A73306B76...\n",
       "263226    48503858427338495063436E4365424F7A6C4A597A6755...\n",
       "263227    75572F37525978475172437251716E4562427A534C612B...\n",
       "263228    3547336A34564D5762784E36553048456968677A6A6764...\n",
       "263229    774830446A62336F7458374C692B7936392B66572B5971...\n",
       "263230    3950795A2F4D6B504C496D497365326C3673796B79466C...\n",
       "263231    69585062573656333649617A31624B785847554E6A2B52...\n",
       "263232    375377366869746F77535A2F51746D47376B4B706F7656...\n",
       "263233    673158506F747563303271556E544F4A6571697461774D...\n",
       "263234    685756705848574C6542566E43354E63372B44786F4575...\n",
       "263235    30614B68747A7A352F73683352415654674F37796D6236...\n",
       "263236    7A3745473857634A3445757A4E646E4A31345738354358...\n",
       "263237    45342B667455486D4E5252574D74676F39336D78723733...\n",
       "263238    7336756B307654316F37486B6F434A5654453065673753...\n",
       "263239    6265544A7168757A304551726F656777396F6C7A365568...\n",
       "263240    2F45355374477156745462664850566C3455304C6E616E...\n",
       "263241    2B6D327A337739663072654A4F336F794176302B6B4162...\n",
       "263242    365A756152377669727977347A4543533051506176496C...\n",
       "263243    7431555233354666715463434B65676B322F7934764E50...\n",
       "263244    366C722F4D62765A4246736C644F6D74694D774A775074...\n",
       "Name: cert_no_cipher, Length: 263245, dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-11-01T03:07:54.397673Z",
     "start_time": "2019-11-01T03:07:53.532022Z"
    }
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\ProgramData\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:1: FutureWarning: The signature of `Series.to_csv` was aligned to that of `DataFrame.to_csv`, and argument 'header' will change its default value from False to True: please pass an explicit value to suppress this warning.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "data.to_csv('cert.txt',index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
